﻿CREATE TABLE [dbo].[UserRole]
(
    [RoleId] BIGINT NOT NULL, 
	[UserId] BIGINT NOT NULL , 
    [TagId] BIGINT NOT NULL, 
    PRIMARY KEY ([UserId], [TagId], [RoleId]), 
    CONSTRAINT [FK_UserRoeToRole] FOREIGN KEY ([RoleId]) REFERENCES [Role]([Id]), 
    CONSTRAINT [FK_UserRoleToTag] FOREIGN KEY ([TagId]) REFERENCES [Tag]([Id])
)
